{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["AST","GLUC  ","TBili","CREA","ALT","PHOS","AMYL","ALP","CO2","BUN"],"not_rendered":{"charts":10,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AST","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,0,3,10],[7,0,7,2],[29,1,29,2],[31,1,31,2],[5,3,5,7],[5,9,5,10],[6,3,6,7],[5,0,5,2],[6,1,6,2]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 1 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"AST"]
["Proposed Reference Range:",null,null,0,"to",38,null,"Units:","U/L"]
[]
[{"$nulls":5},14,11,18,13,26]
[{"$nulls":5},17,17,19,17,17]
[{"$nulls":5},18,25,16,21,17]
[{"$nulls":5},19,17,12,13,17]
[]
[{"$f":"I8","v":"U/L"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<0"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"U/L"}]
[{"$f":"D8&\"-\"&G18","v":"0-7.6"},0,{"$f":"B17/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8-0.0001","v":-0.0001},{"$f":"F8-D8","v":38}]
[{"$f":"G18&\"-\"&G19","v":"7.6-11.4"},1,{"$f":"B18/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.2*H17)","v":7.6000000000000005}]
[{"$f":"G19&\"-\"&G20","v":"11.4-15.2"},4,{"$f":"B19/COUNT($F$10:$J$13)","v":0.20000000000000001},null,null,null,{"$f":"D8+(0.3*H17)","v":11.4}]
[{"$f":"G20&\"-\"&G21","v":"15.2-19"},12,{"$f":"B20/COUNT($F$10:$J$13)","v":0.59999999999999998},null,null,null,{"$f":"D8+(0.4*H17)","v":15.200000000000001}]
[{"$f":"G21&\"-\"&G22","v":"19-26.6"},3,{"$f":"B21/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8+(0.5*H17)","v":19}]
[{"$f":"G22&\"-\"&G23","v":"26.6-30.4"},0,{"$f":"B22/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.7*H17)","v":26.599999999999998}]
[{"$f":"G23&\"-\"&G24","v":"30.4-34.2"},0,{"$f":"B23/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.8*H17)","v":30.400000000000002}]
[{"$f":"G24&\"-\"&G25","v":"34.2-38"},0,{"$f":"B24/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.9*H17)","v":34.200000000000003}]
[{"$f":"\">\"&G25","v":">38"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"F8","v":38}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":17.199999999999999}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":3.7919582498256812}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":17}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"11-26"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":11},{"$f":"MAX(F10:J13)","v":26}]

{"sheet":"GLUC  ","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 2 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"GLUC"]
["Proposed Reference Range:",null,null,75,"to",110,null,"Units:","mg/dL"]
[]
[{"$nulls":5},88,74,92,81,90]
[{"$nulls":5},88,93,89,99,84]
[{"$nulls":5},99,101,90,91,91]
[{"$nulls":5},88,89,82,86,98]
[]
[{"$f":"I8","v":"mg/dL"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<75"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":1},{"$f":"B16/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"I8","v":"mg/dL"}]
[{"$f":"D8&\"-\"&G18","v":"75-82"},2,{"$f":"B17/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8-0.0001","v":74.999899999999997},{"$f":"F8-D8","v":35}]
[{"$f":"G18&\"-\"&G19","v":"82-85.5"},1,{"$f":"B18/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.2*H17)","v":82}]
[{"$f":"G19&\"-\"&G20","v":"85.5-89"},6,{"$f":"B19/COUNT($F$10:$J$13)","v":0.29999999999999999},null,null,null,{"$f":"D8+(0.3*H17)","v":85.5}]
[{"$f":"G20&\"-\"&G21","v":"89-92.5"},5,{"$f":"B20/COUNT($F$10:$J$13)","v":0.25},null,null,null,{"$f":"D8+(0.4*H17)","v":89}]
[{"$f":"G21&\"-\"&G22","v":"92.5-99.5"},4,{"$f":"B21/COUNT($F$10:$J$13)","v":0.20000000000000001},null,null,null,{"$f":"D8+(0.5*H17)","v":92.5}]
[{"$f":"G22&\"-\"&G23","v":"99.5-103"},1,{"$f":"B22/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.7*H17)","v":99.5}]
[{"$f":"G23&\"-\"&G24","v":"103-106.5"},0,{"$f":"B23/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.8*H17)","v":103}]
[{"$f":"G24&\"-\"&G25","v":"106.5-110"},0,{"$f":"B24/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.9*H17)","v":106.5}]
[{"$f":"\">\"&G25","v":">110"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"F8","v":110}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":89.650000000000006}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":6.595652475604469}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":89.5}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"74-101"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0.050000000000000003}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":74},{"$f":"MAX(F10:J13)","v":101}]

{"sheet":"TBili","index":2,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 3 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"BILI Total"]
["Proposed Reference Range:",null,null,0,"to",1,null,"Units:","mg/dL"]
[]
[{"$nulls":5},0.28999999999999998,0.68999999999999995,0.66000000000000003,0.95999999999999996,0.51000000000000001]
[{"$nulls":5},0.55000000000000004,0.58999999999999997,0.88,0.73999999999999999,1.01]
[{"$nulls":5},1.0900000000000001,0.37,0.96999999999999997,0.58999999999999997,0.70999999999999996]
[{"$nulls":5},0.79000000000000004,0.78000000000000003,0.28999999999999998,0.46999999999999997,0.52000000000000002]
[]
[{"$f":"I8","v":"mg/dL"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<0"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"mg/dL"}]
[{"$f":"D8&\"-\"&G18","v":"0-0.2"},0,{"$f":"B17/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8-0.0001","v":-0.0001},{"$f":"F8-D8","v":1}]
[{"$f":"G18&\"-\"&G19","v":"0.2-0.3"},2,{"$f":"B18/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.2*H17)","v":0.20000000000000001}]
[{"$f":"G19&\"-\"&G20","v":"0.3-0.4"},1,{"$f":"B19/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.3*H17)","v":0.29999999999999999}]
[{"$f":"G20&\"-\"&G21","v":"0.4-0.5"},1,{"$f":"B20/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.4*H17)","v":0.40000000000000002}]
[{"$f":"G21&\"-\"&G22","v":"0.5-0.7"},7,{"$f":"B21/COUNT($F$10:$J$13)","v":0.34999999999999998},null,null,null,{"$f":"D8+(0.5*H17)","v":0.5}]
[{"$f":"G22&\"-\"&G23","v":"0.7-0.8"},4,{"$f":"B22/COUNT($F$10:$J$13)","v":0.20000000000000001},null,null,null,{"$f":"D8+(0.7*H17)","v":0.69999999999999996}]
[{"$f":"G23&\"-\"&G24","v":"0.8-0.9"},1,{"$f":"B23/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.8*H17)","v":0.80000000000000004}]
[{"$f":"G24&\"-\"&G25","v":"0.9-1"},2,{"$f":"B24/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.9*H17)","v":0.90000000000000002}]
[{"$f":"\">\"&G25","v":">1"},2,{"$f":"B25/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"F8","v":1}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":0.67299999999999982}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":0.23369120425760279}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":0.67500000000000004}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"0.29-1.09"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0.10000000000000001}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":0.28999999999999998},{"$f":"MAX(F10:J13)","v":1.0900000000000001}]

{"sheet":"CREA","index":3,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 4 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"Creatinine"]
["Proposed Reference Range:",null,null,0.5,"to",1.2,null,"Units:","mg/dL"]
[]
[{"$nulls":5},0.65000000000000002,0.88,0.75,0.58999999999999997,0.78000000000000003]
[{"$nulls":5},0.66000000000000003,0.93999999999999995,1.01,0.73999999999999999,0.64000000000000001]
[{"$nulls":5},0.70999999999999996,1.1100000000000001,0.87,0.56000000000000005,0.97999999999999998]
[{"$nulls":5},0.88,0.85999999999999999,0.56999999999999995,0.76000000000000001,0.59999999999999998]
[]
[{"$f":"I8","v":"mg/dL"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<0.5"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"mg/dL"}]
[{"$f":"D8&\"-\"&G18","v":"0.5-0.64"},5,{"$f":"B17/COUNT($F$10:$J$13)","v":0.25},null,null,null,{"$f":"D8-0.0001","v":0.49990000000000001},{"$f":"F8-D8","v":0.69999999999999996}]
[{"$f":"G18&\"-\"&G19","v":"0.64-0.71"},3,{"$f":"B18/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8+(0.2*H17)","v":0.64000000000000001}]
[{"$f":"G19&\"-\"&G20","v":"0.71-0.78"},4,{"$f":"B19/COUNT($F$10:$J$13)","v":0.20000000000000001},null,null,null,{"$f":"D8+(0.3*H17)","v":0.70999999999999996}]
[{"$f":"G20&\"-\"&G21","v":"0.78-0.85"},0,{"$f":"B20/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.4*H17)","v":0.78000000000000003}]
[{"$f":"G21&\"-\"&G22","v":"0.85-0.99"},6,{"$f":"B21/COUNT($F$10:$J$13)","v":0.29999999999999999},null,null,null,{"$f":"D8+(0.5*H17)","v":0.84999999999999998}]
[{"$f":"G22&\"-\"&G23","v":"0.99-1.06"},1,{"$f":"B22/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.7*H17)","v":0.98999999999999999}]
[{"$f":"G23&\"-\"&G24","v":"1.06-1.13"},1,{"$f":"B23/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.8*H17)","v":1.0600000000000001}]
[{"$f":"G24&\"-\"&G25","v":"1.13-1.2"},0,{"$f":"B24/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.9*H17)","v":1.1299999999999999}]
[{"$f":"\">\"&G25","v":">1.2"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"F8","v":1.2}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":0.77699999999999991}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":0.1591788137185414}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":0.755}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"0.56-1.11"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":0.56000000000000005},{"$f":"MAX(F10:J13)","v":1.1100000000000001}]

{"sheet":"ALT","index":4,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 5 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"ALT"]
["Proposed Reference Range:",null,null,0,"to",41,null,"Units:","U/L"]
[]
[{"$nulls":5},12,14,17,12,38]
[{"$nulls":5},14,23,32,18,5]
[{"$nulls":5},24,24,10,16,14]
[{"$nulls":5},20,18,11,14,12]
[]
[{"$f":"I8","v":"U/L"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<0"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"U/L"}]
[{"$f":"D8&\"-\"&G18","v":"0-8.2"},1,{"$f":"B17/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8-0.0001","v":-0.0001},{"$f":"F8-D8","v":41}]
[{"$f":"G18&\"-\"&G19","v":"8.2-12.3"},5,{"$f":"B18/COUNT($F$10:$J$13)","v":0.25},null,null,null,{"$f":"D8+(0.2*H17)","v":8.2000000000000011}]
[{"$f":"G19&\"-\"&G20","v":"12.3-16.4"},5,{"$f":"B19/COUNT($F$10:$J$13)","v":0.25},null,null,null,{"$f":"D8+(0.3*H17)","v":12.299999999999999}]
[{"$f":"G20&\"-\"&G21","v":"16.4-20.5"},4,{"$f":"B20/COUNT($F$10:$J$13)","v":0.20000000000000001},null,null,null,{"$f":"D8+(0.4*H17)","v":16.400000000000002}]
[{"$f":"G21&\"-\"&G22","v":"20.5-28.7"},3,{"$f":"B21/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8+(0.5*H17)","v":20.5}]
[{"$f":"G22&\"-\"&G23","v":"28.7-32.8"},1,{"$f":"B22/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.7*H17)","v":28.699999999999999}]
[{"$f":"G23&\"-\"&G24","v":"32.8-36.9"},0,{"$f":"B23/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.8*H17)","v":32.800000000000004}]
[{"$f":"G24&\"-\"&G25","v":"36.9-41"},1,{"$f":"B24/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.9*H17)","v":36.899999999999999}]
[{"$f":"\">\"&G25","v":">41"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"F8","v":41}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":17.399999999999999}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":7.7758059321678576}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":15}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"5-38"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":5},{"$f":"MAX(F10:J13)","v":38}]

{"sheet":"PHOS","index":5,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 6 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"PHOS"]
["Proposed Reference Range:",null,null,2.7000000000000002,"to",4.5,null,"Units:","U/L"]
[]
[{"$nulls":5},5.2999999999999998,4.5,3.2000000000000002,2.7000000000000002,3.7000000000000002]
[{"$nulls":5},4.0999999999999996,3.5,3.7999999999999998,3.5,3.7999999999999998]
[{"$nulls":5},3.2999999999999998,2.8999999999999999,3.7999999999999998,4.0999999999999996,3.6000000000000001]
[{"$nulls":5},3.7000000000000002,3.7000000000000002,3.7000000000000002,3.1000000000000001,4.0999999999999996]
[]
[{"$f":"I8","v":"U/L"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<2.7"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"U/L"}]
[{"$f":"D8&\"-\"&G18","v":"2.7-3.06"},2,{"$f":"B17/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8-0.0001","v":2.6999},{"$f":"F8-D8","v":1.7999999999999998}]
[{"$f":"G18&\"-\"&G19","v":"3.06-3.24"},2,{"$f":"B18/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.2*H17)","v":3.0600000000000001}]
[{"$f":"G19&\"-\"&G20","v":"3.24-3.42"},1,{"$f":"B19/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.3*H17)","v":3.2400000000000002}]
[{"$f":"G20&\"-\"&G21","v":"3.42-3.6"},3,{"$f":"B20/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8+(0.4*H17)","v":3.4199999999999999}]
[{"$f":"G21&\"-\"&G22","v":"3.6-3.96"},7,{"$f":"B21/COUNT($F$10:$J$13)","v":0.34999999999999998},null,null,null,{"$f":"D8+(0.5*H17)","v":3.6000000000000001}]
[{"$f":"G22&\"-\"&G23","v":"3.96-4.14"},3,{"$f":"B22/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8+(0.7*H17)","v":3.96}]
[{"$f":"G23&\"-\"&G24","v":"4.14-4.32"},0,{"$f":"B23/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.8*H17)","v":4.1400000000000006}]
[{"$f":"G24&\"-\"&G25","v":"4.32-4.5"},1,{"$f":"B24/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.9*H17)","v":4.3200000000000003}]
[{"$f":"\">\"&G25","v":">4.5"},1,{"$f":"B25/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"F8","v":4.5}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":3.7049999999999992}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":0.57167804704544389}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":3.7000000000000002}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"2.7-5.3"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0.050000000000000003}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":2.7000000000000002},{"$f":"MAX(F10:J13)","v":5.2999999999999998}]

{"sheet":"AMYL","index":6,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 7 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"AMYL"]
["Proposed Reference Range:",null,null,28,"to",100,null,"Units:","U/L"]
[]
[{"$nulls":5},63,104,58,59,54]
[{"$nulls":5},60,72,47,63,60]
[{"$nulls":5},97,112,73,53,38]
[{"$nulls":5},71,42,57,74,87]
[]
[{"$f":"I8","v":"U/L"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<28"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"U/L"}]
[{"$f":"D8&\"-\"&G18","v":"28-42.4"},2,{"$f":"B17/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8-0.0001","v":27.9999},{"$f":"F8-D8","v":72}]
[{"$f":"G18&\"-\"&G19","v":"42.4-49.6"},1,{"$f":"B18/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.2*H17)","v":42.399999999999999}]
[{"$f":"G19&\"-\"&G20","v":"49.6-56.8"},2,{"$f":"B19/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.3*H17)","v":49.599999999999994}]
[{"$f":"G20&\"-\"&G21","v":"56.8-64"},7,{"$f":"B20/COUNT($F$10:$J$13)","v":0.34999999999999998},null,null,null,{"$f":"D8+(0.4*H17)","v":56.799999999999997}]
[{"$f":"G21&\"-\"&G22","v":"64-78.4"},4,{"$f":"B21/COUNT($F$10:$J$13)","v":0.20000000000000001},null,null,null,{"$f":"D8+(0.5*H17)","v":64}]
[{"$f":"G22&\"-\"&G23","v":"78.4-85.6"},0,{"$f":"B22/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.7*H17)","v":78.400000000000006}]
[{"$f":"G23&\"-\"&G24","v":"85.6-92.8"},1,{"$f":"B23/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.8*H17)","v":85.599999999999994}]
[{"$f":"G24&\"-\"&G25","v":"92.8-100"},1,{"$f":"B24/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.9*H17)","v":92.799999999999997}]
[{"$f":"\">\"&G25","v":">100"},2,{"$f":"B25/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"F8","v":100}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":67.200000000000003}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":19.768662069042502}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":61.5}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"38-112"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0.10000000000000001}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":38},{"$f":"MAX(F10:J13)","v":112}]

{"sheet":"ALP","index":7,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 8 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"ALP"]
["Proposed Reference Range:",null,null,40,"to",129,null,"Units:","U/L"]
[]
[{"$nulls":5},100,99,92,59,75]
[{"$nulls":5},88,91,94,84,61]
[{"$nulls":5},108,77,93,85,91]
[{"$nulls":5},112,83,72,70,51]
[]
[{"$f":"I8","v":"U/L"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<40"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"U/L"}]
[{"$f":"D8&\"-\"&G18","v":"40-57.8"},1,{"$f":"B17/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8-0.0001","v":39.999899999999997},{"$f":"F8-D8","v":89}]
[{"$f":"G18&\"-\"&G19","v":"57.8-66.7"},2,{"$f":"B18/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.2*H17)","v":57.799999999999997}]
[{"$f":"G19&\"-\"&G20","v":"66.7-75.6"},3,{"$f":"B19/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8+(0.3*H17)","v":66.700000000000003}]
[{"$f":"G20&\"-\"&G21","v":"75.6-84.5"},3,{"$f":"B20/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8+(0.4*H17)","v":75.599999999999994}]
[{"$f":"G21&\"-\"&G22","v":"84.5-102.3"},9,{"$f":"B21/COUNT($F$10:$J$13)","v":0.45000000000000001},null,null,null,{"$f":"D8+(0.5*H17)","v":84.5}]
[{"$f":"G22&\"-\"&G23","v":"102.3-111.2"},1,{"$f":"B22/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.7*H17)","v":102.3}]
[{"$f":"G23&\"-\"&G24","v":"111.2-120.1"},1,{"$f":"B23/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.8*H17)","v":111.2}]
[{"$f":"G24&\"-\"&G25","v":"120.1-129"},0,{"$f":"B24/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.9*H17)","v":120.10000000000001}]
[{"$f":"\">\"&G25","v":">129"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"F8","v":129}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":84.25}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":16.081617488692846}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":86.5}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"51-112"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":51},{"$f":"MAX(F10:J13)","v":112}]

{"sheet":"CO2","index":8,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 9 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"CO2-L"]
["Proposed Reference Range:",null,null,22,"to",34,null,"Units:","mmol/l"]
[]
[{"$nulls":5},26.399999999999999,27.399999999999999,30,23.399999999999999,25.800000000000001]
[{"$nulls":5},24.300000000000001,27.199999999999999,31.100000000000001,24.600000000000001,24]
[{"$nulls":5},26.399999999999999,27.199999999999999,28.899999999999999,27.199999999999999,27.699999999999999]
[{"$nulls":5},26.899999999999999,26.899999999999999,25.5,26,26.399999999999999]
[]
[{"$f":"I8","v":"mmol/l"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<22"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"mmol/l"}]
[{"$f":"D8&\"-\"&G18","v":"22-24.4"},3,{"$f":"B17/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8-0.0001","v":21.9999},{"$f":"F8-D8","v":12}]
[{"$f":"G18&\"-\"&G19","v":"24.4-25.6"},2,{"$f":"B18/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.2*H17)","v":24.399999999999999}]
[{"$f":"G19&\"-\"&G20","v":"25.6-26.8"},5,{"$f":"B19/COUNT($F$10:$J$13)","v":0.25},null,null,null,{"$f":"D8+(0.3*H17)","v":25.600000000000001}]
[{"$f":"G20&\"-\"&G21","v":"26.8-28"},7,{"$f":"B20/COUNT($F$10:$J$13)","v":0.34999999999999998},null,null,null,{"$f":"D8+(0.4*H17)","v":26.800000000000001}]
[{"$f":"G21&\"-\"&G22","v":"28-30.4"},2,{"$f":"B21/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.5*H17)","v":28}]
[{"$f":"G22&\"-\"&G23","v":"30.4-31.6"},1,{"$f":"B22/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.7*H17)","v":30.399999999999999}]
[{"$f":"G23&\"-\"&G24","v":"31.6-32.8"},0,{"$f":"B23/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.8*H17)","v":31.600000000000001}]
[{"$f":"G24&\"-\"&G25","v":"32.8-34"},0,{"$f":"B24/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.9*H17)","v":32.799999999999997}]
[{"$f":"\">\"&G25","v":">34"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"F8","v":34}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":26.664999999999992}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":1.9021525203112171}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":26.649999999999999}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"23.4-31.1"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":23.399999999999999},{"$f":"MAX(F10:J13)","v":31.100000000000001}]

{"sheet":"BUN","index":9,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,7,2],[29,1,29,2],[31,1,31,2],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 500 (version 1.0). Reference Range Verification (Chemistry)_Example. Page 10 of 10"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",null,null,"COBAS c311",{"$nulls":4},"Date:","2023-07-19"]
[null,"Analyte",null,"BUN"]
["Proposed Reference Range:",null,null,7,"to",19,null,"Units:","mg/dl"]
[]
[{"$nulls":5},12,13,11,9,19]
[{"$nulls":5},13,11,10,7,8]
[{"$nulls":5},10,13,10,8,12]
[{"$nulls":5},17,13,8,7,9]
[]
[{"$f":"I8","v":"mg/dl"},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<7"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"I8","v":"mg/dl"}]
[{"$f":"D8&\"-\"&G18","v":"7-9.4"},7,{"$f":"B17/COUNT($F$10:$J$13)","v":0.34999999999999998},null,null,null,{"$f":"D8-0.0001","v":6.9999000000000002},{"$f":"F8-D8","v":12}]
[{"$f":"G18&\"-\"&G19","v":"9.4-10.6"},3,{"$f":"B18/COUNT($F$10:$J$13)","v":0.14999999999999999},null,null,null,{"$f":"D8+(0.2*H17)","v":9.4000000000000004}]
[{"$f":"G19&\"-\"&G20","v":"10.6-11.8"},2,{"$f":"B19/COUNT($F$10:$J$13)","v":0.10000000000000001},null,null,null,{"$f":"D8+(0.3*H17)","v":10.6}]
[{"$f":"G20&\"-\"&G21","v":"11.8-13"},6,{"$f":"B20/COUNT($F$10:$J$13)","v":0.29999999999999999},null,null,null,{"$f":"D8+(0.4*H17)","v":11.800000000000001}]
[{"$f":"G21&\"-\"&G22","v":"13-15.4"},0,{"$f":"B21/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.5*H17)","v":13}]
[{"$f":"G22&\"-\"&G23","v":"15.4-16.6"},0,{"$f":"B22/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"D8+(0.7*H17)","v":15.399999999999999}]
[{"$f":"G23&\"-\"&G24","v":"16.6-17.8"},1,{"$f":"B23/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.8*H17)","v":16.600000000000001}]
[{"$f":"G24&\"-\"&G25","v":"17.8-19"},1,{"$f":"B24/COUNT($F$10:$J$13)","v":0.050000000000000003},null,null,null,{"$f":"D8+(0.9*H17)","v":17.800000000000001}]
[{"$f":"\">\"&G25","v":">19"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":0},null,null,null,{"$f":"F8","v":19}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":11}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":3.1455900626281967}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":10.5}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"7-19"}]
["Obs Outside:  ",{"$f":"C16+C25","v":0}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":"Acceptable"}]
[]
[null,{"$f":"MIN(F10:J13)","v":7},{"$f":"MAX(F10:J13)","v":19}]